Return-Path: X-Original-To: pgsql-general-postgresql.org@localhost.postgresql.org Delivered-To: pgsql-general-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 5E30C32BCFD for ; Thu, 14 Oct 2004 08:34:06 +0100 (BST) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 87007-08 for ; Thu, 14 Oct 2004 07:34:03 +0000 (GMT) Received: from mailserver.antik.sk (mailserver.antik.sk [62.65.180.241]) by svr1.postgresql.org (Postfix) with SMTP id 1F92932B980 for ; Thu, 14 Oct 2004 08:34:02 +0100 (BST) Received: (qmail 3875 invoked by uid 1178); 14 Oct 2004 07:33:59 -0000 Received: from bartkoedith@internetkosice.sk by mail.antik.sk by uid 503 with qmail-scanner-1.22-st-qms (antik mailSCAN 1.22/0.75 Clear:RC:1(62.65.180.251):SA:0(-3.3/2.0):. Processed in 7.004999 secs); 14 Oct 2004 07:33:59 -0000 Received: from web.antik.sk (HELO mail.netkosice.sk) (62.65.180.251) by mailserver.antik.sk with SMTP; 14 Oct 2004 07:33:52 -0000 Received: from 213.81.203.55 (SquirrelMail authenticated user bartkoedith@internetkosice.sk) by www.netkosice.sk with HTTP; Thu, 14 Oct 2004 09:33:53 +0200 (CEST) Message-ID: <10180.213.81.203.55.1097739233.squirrel@www.netkosice.sk> In-Reply-To: <6BCB9D8A16AC4241919521715F4D8BCE456A1B@algol.sollentuna.se> References: <6BCB9D8A16AC4241919521715F4D8BCE456A1B@algol.sollentuna.se> Date: Thu, 14 Oct 2004 09:33:53 +0200 (CEST) Subject: RE: [GENERAL] beta3 winxp initdb problems From: bartkoedith@internetkosice.sk To: pgsql-general@postgresql.org Cc: "Magnus Hagander" User-Agent: SquirrelMail/1.4.2 MIME-Version: 1.0 Content-Type: text/plain;charset=iso-8859-2 Content-Transfer-Encoding: 8bit X-Priority: 3 Importance: Normal X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=1.1 tagged_above=0.0 required=5.0 tests=NO_REAL_NAME, PRIORITY_NO_NAME X-Spam-Level: * Magnus, et al., This is, what initdb -d says: D:\tmp\data>initdb -d Running in debug mode. VERSION=8.0.0beta3 PGDATA=d:/tmp/data share_path=c:/msys/1.0/share/postgresql PGPATH=c:/msys/1.0/bin POSTGRES_SUPERUSERNAME=postgresql POSTGRES_BKI=c:/msys/1.0/share/postgresql/postgres.bki POSTGRES_DESCR=c:/msys/1.0/share/postgresql/postgres.description POSTGRESQL_CONF_SAMPLE=c:/msys/1.0/share/postgresql/postgresql.conf.sample PG_HBA_SAMPLE=c:/msys/1.0/share/postgresql/pg_hba.conf.sample PG_IDENT_SAMPLE=c:/msys/1.0/share/postgresql/pg_ident.conf.sample The files belonging to this database system will be owned by user "postgresql". This user must also own the server process. The database cluster will be initialized with locale Slovak_Slovakia.1250. fixing permissions on existing directory d:/tmp/data ... ok creating directory d:/tmp/data/global ... ok creating directory d:/tmp/data/pg_xlog ... ok creating directory d:/tmp/data/pg_xlog/archive_status ... ok creating directory d:/tmp/data/pg_clog ... ok creating directory d:/tmp/data/pg_subtrans ... ok creating directory d:/tmp/data/base ... ok creating directory d:/tmp/data/base/1 ... ok creating directory d:/tmp/data/pg_tblspc ... ok selecting default max_connections ... 10 selecting default shared_buffers ... 50 creating configuration files ... ok creating template1 database in d:/tmp/data/base/1 ... DEBUG: TZ "Europe/Belgrad e" matches Windows timezone "Central Europe Daylight Time" FATAL: could not select a suitable default timezone DETAIL: It appears that your GMT time zone uses leap seconds. PostgreSQL does n ot support leap seconds. DEBUG: proc_exit(1) DEBUG: shmem_exit(1) DEBUG: exit(1) child process was terminated by signal 1 initdb: failed initdb: removing contents of data directory "d:/tmp/data" D:\tmp\data> So I said to myself, set the timezone to GMT. This, what I got after switching off the automatic daylight saving time notification: D:\tmp\data>initdb -d Running in debug mode. VERSION=8.0.0beta3 PGDATA=d:/tmp/data share_path=c:/msys/1.0/share/postgresql PGPATH=c:/msys/1.0/bin POSTGRES_SUPERUSERNAME=postgresql POSTGRES_BKI=c:/msys/1.0/share/postgresql/postgres.bki POSTGRES_DESCR=c:/msys/1.0/share/postgresql/postgres.description POSTGRESQL_CONF_SAMPLE=c:/msys/1.0/share/postgresql/postgresql.conf.sample PG_HBA_SAMPLE=c:/msys/1.0/share/postgresql/pg_hba.conf.sample PG_IDENT_SAMPLE=c:/msys/1.0/share/postgresql/pg_ident.conf.sample The files belonging to this database system will be owned by user "postgresql". This user must also own the server process. The database cluster will be initialized with locale Slovak_Slovakia.1250. fixing permissions on existing directory d:/tmp/data ... ok creating directory d:/tmp/data/global ... ok creating directory d:/tmp/data/pg_xlog ... ok creating directory d:/tmp/data/pg_xlog/archive_status ... ok creating directory d:/tmp/data/pg_clog ... ok creating directory d:/tmp/data/pg_subtrans ... ok creating directory d:/tmp/data/base ... ok creating directory d:/tmp/data/base/1 ... ok creating directory d:/tmp/data/pg_tblspc ... ok selecting default max_connections ... 10 selecting default shared_buffers ... 50 creating configuration files ... ok creating template1 database in d:/tmp/data/base/1 ... DEBUG: TZ "Europe/Dublin" matches Windows timezone "GMT Standard Time" FATAL: could not select a suitable default timezone DETAIL: It appears that your GMT time zone uses leap seconds. PostgreSQL does n ot support leap seconds. DEBUG: proc_exit(1) DEBUG: shmem_exit(1) DEBUG: exit(1) child process was terminated by signal 1 initdb: failed initdb: removing contents of data directory "d:/tmp/data" D:\tmp\data> Any ideas? Zoltan > > Hello! > > Could you please run this with debugging enabled? You do this by passing > "-d" to initdb. > The interesting output is the stuff that comes between the "creating > template1 database" message and the FATAL error. > > Did you restart the commandprompt you ran initdb in after changing the > timezone? > > //Magnus > >